MySQL Interview Questions and Answers
Ques 26. What Is BDB (BerkeleyDB)?
BDB (BerkeleyDB) is transaction safe storage engine originally developed at U.C. Berkeley. It is now developed by Sleepycat Software, Inc. (an Oracle company now).
Ques 27. What Is CSV?
CSV (Comma Separated Values) is a file format used to store database table contents, where one table row is stored as one line in the file, and each data field is separated with comma.
Ques 28. What Is Transaction?
A transaction is a logical unit of work requested by a user to be applied to the database objects. MySQL server introduces the transaction concept to allow users to group one or more SQL statements into a single transaction, so that the effects of all the SQL statements in a transaction can be either all committed (applied to the database) or all rolled back (undone from the database).
Ques 29. What Is Commit?
Commit is a way to terminate a transaction with all database changes to be saved permanently to the database server.
Ques 30. What Is Rollback?
Rollback is a way to terminate a transaction with all database changes not saving to the database server.
Most helpful rated by users: